TDAScript class overview.
Properties
| Name | Description |
|
Connection |
Used to specify the connection in which the script will be executed.
|
|
DataSet |
Refers to a dataset that holds the result set of query execution.
|
|
Debug |
Used to display the script execution and all its parameter values.
|
|
Delimiter |
Used to set the delimiter string that separates script statements.
|
|
EndLine |
Used to get the current statement last line number in a script.
|
|
EndOffset |
Used to get the offset in the last line of the current statement.
|
|
EndPos |
Used to get the end position of the current statement.
|
|
Macros |
Used to change SQL script text in design- or run-time easily.
|
|
SQL |
Used to get or set script text.
|
|
StartLine |
Used to get the current statement start line number in a script.
|
|
StartOffset |
Used to get the offset in the first line of the current statement.
|
|
StartPos |
Used to get the start position of the current statement in a script.
|
|
Statements |
Contains a list of statements obtained from the SQL property.
|
Methods
| Name | Description |
|
BreakExec |
Stops script execution.
|
|
ErrorOffset |
Used to get the offset of the statement if the Execute method raised an exception.
|
|
Execute |
Executes a script.
|
|
ExecuteFile |
Executes SQL statements contained in a file.
|
|
ExecuteNext |
Executes the next statement in the script and then stops.
|
|
ExecuteStream |
Executes SQL statements contained in a stream object.
|
|
FindMacro |
Finds a macro with the specified name.
|
|
MacroByName |
Finds a macro with the specified name.
|
Events
| Name | Description |
|
AfterExecute |
Occurs after a SQL script execution.
|
|
BeforeExecute |
Occurs when taking a specific action before executing the current SQL statement is needed.
|
|
OnError |
Occurs when SQL Server raises an error.
|
